package cn.platform.mapper;

import cn.platform.entity.StuRecord;
import cn.platform.request.StuRecord.StuRecordRequest;
import cn.platform.response.StuRecordVO;
import com.github.pagehelper.Page;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;
@Mapper
public interface StuRecordMapper {


    @Select("SELECT * FROM jxt_stu_records WHERE id = #{id}")
    StuRecord getupdateById(String id);


    @Select("SELECT * FROM jxt_stu_records WHERE id = #{id}")
    StuRecord getById(Integer id);

    // 修改查询方法，添加多表关联
    Page<StuRecordVO> pageQuery(Map<String, Object> map);

    @Delete("delete from jxt_stu_records where id=#{id};")
    void deleteById(Integer id);

    void deleteBatch(List<Integer> ids);

    void insertStuRecord(StuRecord stuRecord);

    void updateStuRecord(StuRecord stuRecord);
}
